PX server shutdown
During normal or immediate shutdown the parallel execution slaves are posted to shutdown cleanly. If any parallel execution slaves are still alive after 10 seconds, they are killed.
Disclaimer​
The terms master and slave have historically been used by vendors in database wait events. DBmarlin does not support or condone the use of these terms. As vendors remove these terms from their software, occurrences will reduce.
Detailed Description​
During normal or immediate shutdown the parallel execution workers are posted to shutdown cleanly. If any parallel execution workers are still alive after 10 seconds, they are killed.
How to reduce this wait​
Refer to My Oracle Support for the "Master Note for Parallel Execution Wait Events".
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.